#!/bin/sh

echo "analysis user click......"
currentdate=`date +%Y-%m-%d`
echo "current date: $currentdate"
hive -e "use homework;
insert into table user_info
select id,to_date(click_time) currentdate
from user_clicks
where to_date(click_time) = '$currentdate'
group by id,to_date(click_time);"